{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","I-Beam Info","Help"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Distributed Load (q) =",5.8,"lbs/ft",null,null,null,null,null,null,null,"The lightest beam you could use is:","W 8 X 15"]
[null,null,null,"Point Load (P) =",22.5,"lbs"]
[null,null,null,"Length of Beam (L) =",5,"ft"]
[null,null,null,"Position of Point Load (x) =",3.5,"ft"]
[null,null,null,"σAllow =",36000,"psi"]
[]
[null,"Calculated Values"]
[null,null,"Reaction Force A (ay) =",{"$f":"(q*l)+p-D19","v":21.25},"lbs"]
[null,null,"Reaction Force B (by) =",{"$f":"(p*x/l)+(q*l/2)","v":30.25},"lbs"]
[null,null,"Max Moment (mmax)=",{"$f":"maxmoment(D18, q, x)","v":38.85},"ft*lbs"]
[null,null,"S (s) =",1.295E-2,"in^3"]
[]
[]
["Acceptable Beams"]
["W 30 X 211"]
["W 30 X 132"]
["W 24 X 162"]
["W 24 X 94"]
["W 18 X 119"]
["W 18 X 71"]
["W 16 X 100"]
["W 16 X 77"]
["W 16 X 57"]
["W 16 X 31"]
["W 14 X 120"]
["W 14 X 82"]
["W 14 X 53"]
["W 14 X 26"]
["W 12 X 87"]
["W 12 X 50"]
["W 12 X 35"]
["W 12 X 14"]
["W 10 X 60"]
["W 10 X 45"]
["W 10 X 30"]
["W 10 X 12"]
["W 8 X 35"]
["W 8 X 28"]
["W 8 X 21"]
["W 8 X 15"]

{"sheet":"I-Beam Info","index":1,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Designation","Mass/meter","s",null,null,null,"Designation","Weight/ft","s"]
["W 760 X 314",314,{"$f":"D2*1000","v":10900000},10900,null,null,"W 30 X 211",211,665]
["W 760 X 196",196,{"$f":"D3*1000","v":6230000},6230,null,null,"W 30 X 132",132,380]
["W 610 X 241",241,6780000,6780,null,null,"W 24 X 162",162,414]
["W 610 X 140",140,3640000,3640,null,null,"W 24 X 94",94,222]
["W 460 X 177",177,3790000,3790,null,null,"W 18 X 119",119,231]
["W 460 X 106",106,2080000,2080,null,null,"W 18 X 71",71,127]
["W 410 X 149",149,2870000,2870,null,null,"W 16 X 100",100,175]
["W 410 X 114",114,2200000,2200,null,null,"W 16 X 77",77,134]
["W 410 X 85",85,1510000,1510,null,null,"W 16 X 57",57,92.2]
["W 410 X 46.1",46.1,773000,773,null,null,"W 16 X 31",31,47.2]
["W 360 X 179",179,3110000,3110,null,null,"W 14 X 120",120,190]
["W 360 X 122",122,2020000,2020,null,null,"W 14 X 82",82,123]
["W 360 X 79",79,1270000,1270,null,null,"W 14 X 53",53,77.8]
["W 360 X 39",39,578000,578,null,null,"W 14 X 26",26,35.299999999999997]
["W 310 X 129",129,1930000,1930,null,null,"W 12 X 87",87,118]
["W 310 X 74",74,1050000,1050,null,null,"W 12 X 50",50,64.2]
["W 310 X 52",52,747000,747,null,null,"W 12 X 35",35,45.6]
["W 310 X 21",21,244000,244,null,null,"W 12 X 14",14,14.9]
["W 250 X 89",89,1090000,1090,null,null,"W 10 X 60",60,66.7]
["W 250 X 67",67,805000,805,null,null,"W 10 X 45",45,49.1]
["W 250 X 44.8",44.8,531000,531,null,null,"W 10 X 30",30,32.4]
["W 250 X 17.9",17.899999999999999,179000,179,null,null,"W 10 X 12",12,10.9]
["W 200 X 52",52,511000,511,null,null,"W 8 X 35",35,31.2]
["W 200 X 41.7",41.7,398000,398,null,null,"W 8 X 28",28,24.3]
["W 200 X 31.3",31.3,298000,298,null,null,"W 8 X 21",21,18.2]
["W 200 X 22.5",22.5,193000,193,null,null,"W 8 X 15",15,11.8]

{"sheet":"Help","index":2,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Objective"]
["This is a simple I beam calculator. It can be used to determine the appropriate W-Shape I beam to use given certain parameters such as distributed loads, length of beam and position of point load. "]
["The cases that our calculator can handle are: "]
["1) Beams with evenly distributed loads."]
["2) Beams with point loads."]
["3) Beams with evenly distributed loads and point loads."]
[]
[]
["User Guide"]
["1) Choose the type of units that will be used: Metric or English."]
["2) Enter in the desired loads the beam will be subject to."]
[null,"a) q is the distributed load in force/length"]
[null,"b) P is the point load as a force"]
["3) Enter in the parameters for the beam itself."]
[null,"a) How long must the beam be? Enter this for the L value."]
[null,"b) Where will the point load be located? X is measured from the left-hand side. Enter this for the x value.*"]
[null,"c) What is the allowable stress for the beam? Enter this for the sigma value."]
[null,"*The x value must be in between 0 and the length of the beam. Failure to comply to this constraint will result in an error message."]
["4) Click on the Find Beam button."]
["5) A list of all acceptable beams will be generated. These are all perfectly strong enough, however some may be much stronger than needed."]
["6) The lightest beam from that list will be displayed. This is the most economical choice."]
[]
["Click on the Generate Sample Data to insert sample data into the tables. "]